Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 106594 |
| Missing cells | 106594 |
| Missing cells (%) | 7.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 18.0 MiB |
| Average record size in memory | 177.0 B |
Variable types
| DateTime | 1 |
|---|---|
| Numeric | 11 |
| Categorical | 1 |
| Unsupported | 1 |
ghi_pyr is highly overall correlated with ghi_rsi and 3 other fields | High correlation |
ghi_rsi is highly overall correlated with ghi_pyr and 2 other fields | High correlation |
dni is highly overall correlated with ghi_pyr and 2 other fields | High correlation |
dhi is highly overall correlated with ghi_pyr and 2 other fields | High correlation |
air_temperature is highly overall correlated with ghi_pyr and 2 other fields | High correlation |
wind_speed is highly overall correlated with wind_speed_of_gust and 1 other fields | High correlation |
wind_speed_of_gust is highly overall correlated with air_temperature and 2 other fields | High correlation |
barometric_pressure is highly overall correlated with air_temperature and 2 other fields | High correlation |
sensor_cleaning is highly imbalanced (99.0%) | Imbalance |
comments has 106594 (100.0%) missing values | Missing |
time has unique values | Unique |
comments is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
ghi_pyr has 51912 (48.7%) zeros | Zeros |
ghi_rsi has 46524 (43.6%) zeros | Zeros |
dni has 58707 (55.1%) zeros | Zeros |
dhi has 46524 (43.6%) zeros | Zeros |
Reproduction
| Analysis started | 2023-07-13 14:25:40.058522 |
|---|---|
| Analysis finished | 2023-07-13 14:26:15.390191 |
| Duration | 35.33 seconds |
| Software version | ydata-profiling vv4.3.1 |
| Download configuration | config.json |
time
Date
UNIQUE 
| Distinct | 106594 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 832.9 KiB |
| Minimum | 2015-04-21 18:30:00 |
|---|---|
| Maximum | 2017-05-01 00:00:00 |
ghi_pyr
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 10332 |
|---|---|
| Distinct (%) | 9.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 249.03033 |
| Minimum | 0 |
|---|---|
| Maximum | 1151.2 |
| Zeros | 51912 |
| Zeros (%) | 48.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 832.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 4 |
| Q3 | 523.7 |
| 95-th percentile | 908.7 |
| Maximum | 1151.2 |
| Range | 1151.2 |
| Interquartile range (IQR) | 523.7 |
Descriptive statistics
| Standard deviation | 329.9626 |
|---|---|
| Coefficient of variation (CV) | 1.3249896 |
| Kurtosis | -0.65099626 |
| Mean | 249.03033 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0.9451745 |
| Sum | 26545139 |
| Variance | 108875.32 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 51912 | |
| 0.2 | 71 | 0.1% |
| 0.3 | 63 | 0.1% |
| 0.1 | 60 | 0.1% |
| 1.1 | 60 | 0.1% |
| 0.5 | 60 | 0.1% |
| 0.4 | 55 | 0.1% |
| 0.6 | 50 | < 0.1% |
| 1.2 | 48 | < 0.1% |
| 1.5 | 47 | < 0.1% |
| Other values (10322) | 54168 |
| Value | Count | Frequency (%) |
| 0 | 51912 | |
| 0.1 | 60 | 0.1% |
| 0.2 | 71 | 0.1% |
| 0.3 | 63 | 0.1% |
| 0.4 | 55 | 0.1% |
| 0.5 | 60 | 0.1% |
| 0.6 | 50 | < 0.1% |
| 0.7 | 41 | < 0.1% |
| 0.8 | 43 | < 0.1% |
| 0.9 | 37 | < 0.1% |
| Value | Count | Frequency (%) |
| 1151.2 | 1 | |
| 1126 | 1 | |
| 1122.4 | 1 | |
| 1116.2 | 1 | |
| 1113.7 | 1 | |
| 1108 | 1 | |
| 1106.8 | 1 | |
| 1096 | 1 | |
| 1092.9 | 1 | |
| 1091.2 | 1 |
ghi_rsi
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 9918 |
|---|---|
| Distinct (%) | 9.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 239.59901 |
| Minimum | 0 |
|---|---|
| Maximum | 1100.9 |
| Zeros | 46524 |
| Zeros (%) | 43.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 832.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3.5 |
| Q3 | 505.1 |
| 95-th percentile | 868.5 |
| Maximum | 1100.9 |
| Range | 1100.9 |
| Interquartile range (IQR) | 505.1 |
Descriptive statistics
| Standard deviation | 316.63119 |
|---|---|
| Coefficient of variation (CV) | 1.3215046 |
| Kurtosis | -0.68002644 |
| Mean | 239.59901 |
| Median Absolute Deviation (MAD) | 3.5 |
| Skewness | 0.93467279 |
| Sum | 25539817 |
| Variance | 100255.31 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 46524 | |
| 0.1 | 1994 | 1.9% |
| 0.2 | 1687 | 1.6% |
| 0.3 | 623 | 0.6% |
| 0.4 | 188 | 0.2% |
| 0.5 | 186 | 0.2% |
| 0.7 | 143 | 0.1% |
| 0.6 | 136 | 0.1% |
| 1.2 | 132 | 0.1% |
| 1.1 | 116 | 0.1% |
| Other values (9908) | 54865 |
| Value | Count | Frequency (%) |
| 0 | 46524 | |
| 0.1 | 1994 | 1.9% |
| 0.2 | 1687 | 1.6% |
| 0.3 | 623 | 0.6% |
| 0.4 | 188 | 0.2% |
| 0.5 | 186 | 0.2% |
| 0.6 | 136 | 0.1% |
| 0.7 | 143 | 0.1% |
| 0.8 | 115 | 0.1% |
| 0.9 | 110 | 0.1% |
| Value | Count | Frequency (%) |
| 1100.9 | 1 | |
| 1082.4 | 1 | |
| 1077.3 | 1 | |
| 1075.9 | 1 | |
| 1070.5 | 1 | |
| 1063.9 | 1 | |
| 1061.9 | 1 | |
| 1055.4 | 1 | |
| 1054.3 | 1 | |
| 1046.4 | 1 |
dni
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 8960 |
|---|---|
| Distinct (%) | 8.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 202.61395 |
| Minimum | 0 |
|---|---|
| Maximum | 993.9 |
| Zeros | 58707 |
| Zeros (%) | 55.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 832.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 443.2 |
| 95-th percentile | 736 |
| Maximum | 993.9 |
| Range | 993.9 |
| Interquartile range (IQR) | 443.2 |
Descriptive statistics
| Standard deviation | 275.36803 |
|---|---|
| Coefficient of variation (CV) | 1.3590774 |
| Kurtosis | -0.65813467 |
| Mean | 202.61395 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.94488169 |
| Sum | 21597431 |
| Variance | 75827.551 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 58707 | |
| 3.1 | 23 | < 0.1% |
| 0.4 | 21 | < 0.1% |
| 3.4 | 19 | < 0.1% |
| 0.3 | 19 | < 0.1% |
| 0.2 | 18 | < 0.1% |
| 0.1 | 18 | < 0.1% |
| 2.5 | 17 | < 0.1% |
| 3.8 | 17 | < 0.1% |
| 670 | 17 | < 0.1% |
| Other values (8950) | 47718 |
| Value | Count | Frequency (%) |
| 0 | 58707 | |
| 0.1 | 18 | < 0.1% |
| 0.2 | 18 | < 0.1% |
| 0.3 | 19 | < 0.1% |
| 0.4 | 21 | < 0.1% |
| 0.5 | 9 | < 0.1% |
| 0.6 | 14 | < 0.1% |
| 0.7 | 15 | < 0.1% |
| 0.8 | 12 | < 0.1% |
| 0.9 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 993.9 | 1 | |
| 989.2 | 1 | |
| 986.5 | 1 | |
| 982.1 | 1 | |
| 981.2 | 1 | |
| 980.9 | 1 | |
| 980.5 | 1 | |
| 978.7 | 1 | |
| 977.8 | 1 | |
| 976.5 | 1 |
dhi
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 5521 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 100.45506 |
| Minimum | 0 |
|---|---|
| Maximum | 673 |
| Zeros | 46524 |
| Zeros (%) | 43.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 832.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3.5 |
| Q3 | 188.1 |
| 95-th percentile | 360.5 |
| Maximum | 673 |
| Range | 673 |
| Interquartile range (IQR) | 188.1 |
Descriptive statistics
| Standard deviation | 130.82675 |
|---|---|
| Coefficient of variation (CV) | 1.3023411 |
| Kurtosis | 0.57838244 |
| Mean | 100.45506 |
| Median Absolute Deviation (MAD) | 3.5 |
| Skewness | 1.1743655 |
| Sum | 10707906 |
| Variance | 17115.638 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 46524 | |
| 0.1 | 1994 | 1.9% |
| 0.2 | 1687 | 1.6% |
| 0.3 | 623 | 0.6% |
| 0.4 | 188 | 0.2% |
| 0.5 | 186 | 0.2% |
| 0.7 | 143 | 0.1% |
| 0.6 | 136 | 0.1% |
| 1.2 | 132 | 0.1% |
| 1.1 | 116 | 0.1% |
| Other values (5511) | 54865 |
| Value | Count | Frequency (%) |
| 0 | 46524 | |
| 0.1 | 1994 | 1.9% |
| 0.2 | 1687 | 1.6% |
| 0.3 | 623 | 0.6% |
| 0.4 | 188 | 0.2% |
| 0.5 | 186 | 0.2% |
| 0.6 | 136 | 0.1% |
| 0.7 | 143 | 0.1% |
| 0.8 | 115 | 0.1% |
| 0.9 | 110 | 0.1% |
| Value | Count | Frequency (%) |
| 673 | 1 | |
| 672.5 | 1 | |
| 670 | 1 | |
| 665.2 | 1 | |
| 664.5 | 1 | |
| 657.1 | 1 | |
| 649.6 | 1 | |
| 649.3 | 1 | |
| 649.1 | 1 | |
| 647.4 | 1 |
air_temperature
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 410 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.692962 |
| Minimum | 7.8 |
|---|---|
| Maximum | 49.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 832.9 KiB |
Quantile statistics
| Minimum | 7.8 |
|---|---|
| 5-th percentile | 15.6 |
| Q1 | 23 |
| median | 28.1 |
| Q3 | 32.4 |
| 95-th percentile | 38.8 |
| Maximum | 49.5 |
| Range | 41.7 |
| Interquartile range (IQR) | 9.4 |
Descriptive statistics
| Standard deviation | 6.9149428 |
|---|---|
| Coefficient of variation (CV) | 0.24970037 |
| Kurtosis | -0.38605333 |
| Mean | 27.692962 |
| Median Absolute Deviation (MAD) | 4.6 |
| Skewness | -0.12704659 |
| Sum | 2951903.6 |
| Variance | 47.816434 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 28.4 | 917 | 0.9% |
| 28.9 | 906 | 0.8% |
| 29.1 | 902 | 0.8% |
| 28.6 | 875 | 0.8% |
| 28.1 | 868 | 0.8% |
| 27.9 | 865 | 0.8% |
| 29.2 | 829 | 0.8% |
| 29.4 | 827 | 0.8% |
| 27.1 | 814 | 0.8% |
| 26.9 | 810 | 0.8% |
| Other values (400) | 97981 |
| Value | Count | Frequency (%) |
| 7.8 | 2 | |
| 7.9 | 1 | < 0.1% |
| 8 | 2 | |
| 8.1 | 1 | < 0.1% |
| 8.2 | 3 | |
| 8.3 | 1 | < 0.1% |
| 8.4 | 1 | < 0.1% |
| 8.5 | 1 | < 0.1% |
| 8.6 | 1 | < 0.1% |
| 8.7 | 2 |
| Value | Count | Frequency (%) |
| 49.5 | 1 | < 0.1% |
| 49 | 2 | |
| 48.9 | 3 | |
| 48.8 | 2 | |
| 48.7 | 3 | |
| 48.6 | 1 | < 0.1% |
| 48.5 | 2 | |
| 48.4 | 2 | |
| 48.3 | 1 | < 0.1% |
| 48.2 | 1 | < 0.1% |
relative_humidity
Real number (ℝ)
| Distinct | 970 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51.710956 |
| Minimum | 2.7 |
|---|---|
| Maximum | 99.9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 832.9 KiB |
Quantile statistics
| Minimum | 2.7 |
|---|---|
| 5-th percentile | 18.8 |
| Q1 | 36 |
| median | 50.8 |
| Q3 | 69.2 |
| 95-th percentile | 83.2 |
| Maximum | 99.9 |
| Range | 97.2 |
| Interquartile range (IQR) | 33.2 |
Descriptive statistics
| Standard deviation | 20.344793 |
|---|---|
| Coefficient of variation (CV) | 0.39343293 |
| Kurtosis | -0.86679879 |
| Mean | 51.710956 |
| Median Absolute Deviation (MAD) | 16.4 |
| Skewness | -0.0074660303 |
| Sum | 5512077.6 |
| Variance | 413.9106 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 36 | 232 | 0.2% |
| 75.5 | 228 | 0.2% |
| 74.5 | 222 | 0.2% |
| 46.1 | 222 | 0.2% |
| 46.5 | 220 | 0.2% |
| 73.8 | 220 | 0.2% |
| 76.8 | 219 | 0.2% |
| 42.9 | 217 | 0.2% |
| 77 | 216 | 0.2% |
| 48 | 215 | 0.2% |
| Other values (960) | 104383 |
| Value | Count | Frequency (%) |
| 2.7 | 2 | < 0.1% |
| 2.9 | 2 | < 0.1% |
| 3 | 1 | < 0.1% |
| 3.1 | 3 | |
| 3.2 | 2 | < 0.1% |
| 3.3 | 2 | < 0.1% |
| 3.5 | 4 | |
| 3.6 | 3 | |
| 3.7 | 5 | |
| 3.8 | 4 |
| Value | Count | Frequency (%) |
| 99.9 | 4 | < 0.1% |
| 99.8 | 3 | < 0.1% |
| 99.7 | 2 | < 0.1% |
| 99.6 | 2 | < 0.1% |
| 99.5 | 5 | < 0.1% |
| 99.4 | 15 | |
| 99.3 | 15 | |
| 99.2 | 9 | |
| 99.1 | 9 | |
| 99 | 5 | < 0.1% |
wind_speed
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 160 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.9719365 |
| Minimum | 0 |
|---|---|
| Maximum | 18.1 |
| Zeros | 680 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 832.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.4 |
| Q1 | 2.9 |
| median | 4.6 |
| Q3 | 6.9 |
| 95-th percentile | 9.5 |
| Maximum | 18.1 |
| Range | 18.1 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.5674802 |
|---|---|
| Coefficient of variation (CV) | 0.51639441 |
| Kurtosis | -0.55304258 |
| Mean | 4.9719365 |
| Median Absolute Deviation (MAD) | 1.9 |
| Skewness | 0.39806157 |
| Sum | 529978.6 |
| Variance | 6.5919547 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.8 | 1779 | 1.7% |
| 3 | 1771 | 1.7% |
| 3.5 | 1728 | 1.6% |
| 2.6 | 1722 | 1.6% |
| 3.1 | 1717 | 1.6% |
| 2.9 | 1690 | 1.6% |
| 3.2 | 1689 | 1.6% |
| 3.8 | 1679 | 1.6% |
| 2.5 | 1670 | 1.6% |
| 3.6 | 1648 | 1.5% |
| Other values (150) | 89501 |
| Value | Count | Frequency (%) |
| 0 | 680 | |
| 0.1 | 195 | 0.2% |
| 0.2 | 210 | 0.2% |
| 0.3 | 212 | 0.2% |
| 0.4 | 228 | 0.2% |
| 0.5 | 231 | 0.2% |
| 0.6 | 300 | |
| 0.7 | 289 | |
| 0.8 | 353 | |
| 0.9 | 386 |
| Value | Count | Frequency (%) |
| 18.1 | 1 | < 0.1% |
| 17.7 | 1 | < 0.1% |
| 17.2 | 1 | < 0.1% |
| 16.6 | 3 | |
| 15.8 | 2 | |
| 15.7 | 1 | < 0.1% |
| 15.6 | 3 | |
| 15.5 | 1 | < 0.1% |
| 15.4 | 1 | < 0.1% |
| 15.3 | 2 |
wind_speed_of_gust
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 199 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.5248344 |
| Minimum | 0 |
|---|---|
| Maximum | 29.5 |
| Zeros | 489 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 832.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.4 |
| Q1 | 4.4 |
| median | 6.9 |
| Q3 | 10.4 |
| 95-th percentile | 14.2 |
| Maximum | 29.5 |
| Range | 29.5 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.7684093 |
|---|---|
| Coefficient of variation (CV) | 0.50079631 |
| Kurtosis | -0.62278485 |
| Mean | 7.5248344 |
| Median Absolute Deviation (MAD) | 2.8 |
| Skewness | 0.40649423 |
| Sum | 802102.2 |
| Variance | 14.200908 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.1 | 3067 | 2.9% |
| 4.9 | 2989 | 2.8% |
| 5.7 | 2806 | 2.6% |
| 3.4 | 2760 | 2.6% |
| 5.4 | 2687 | 2.5% |
| 4.6 | 2640 | 2.5% |
| 5.2 | 2631 | 2.5% |
| 3.9 | 2619 | 2.5% |
| 4.4 | 2600 | 2.4% |
| 6.4 | 2526 | 2.4% |
| Other values (189) | 79269 |
| Value | Count | Frequency (%) |
| 0 | 489 | |
| 0.4 | 23 | < 0.1% |
| 0.6 | 1 | < 0.1% |
| 0.7 | 1 | < 0.1% |
| 0.8 | 127 | 0.1% |
| 1 | 10 | < 0.1% |
| 1.1 | 379 | |
| 1.2 | 4 | < 0.1% |
| 1.3 | 1 | < 0.1% |
| 1.4 | 442 |
| Value | Count | Frequency (%) |
| 29.5 | 1 | |
| 27.4 | 1 | |
| 25.7 | 2 | |
| 25.4 | 1 | |
| 25.2 | 1 | |
| 25 | 1 | |
| 23.2 | 1 | |
| 22.2 | 1 | |
| 21.9 | 2 | |
| 21.7 | 2 |
wind_from_direction_st_dev
Real number (ℝ)
| Distinct | 648 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.725061 |
| Minimum | 0 |
|---|---|
| Maximum | 93.1 |
| Zeros | 971 |
| Zeros (%) | 0.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 832.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3.7 |
| Q1 | 10.7 |
| median | 14.9 |
| Q3 | 17.9 |
| 95-th percentile | 25.7 |
| Maximum | 93.1 |
| Range | 93.1 |
| Interquartile range (IQR) | 7.2 |
Descriptive statistics
| Standard deviation | 6.8215562 |
|---|---|
| Coefficient of variation (CV) | 0.46326167 |
| Kurtosis | 6.3682179 |
| Mean | 14.725061 |
| Median Absolute Deviation (MAD) | 3.6 |
| Skewness | 1.1539733 |
| Sum | 1569603.1 |
| Variance | 46.533628 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16.9 | 1115 | 1.0% |
| 17.1 | 1101 | 1.0% |
| 16.6 | 1050 | 1.0% |
| 17.6 | 1039 | 1.0% |
| 16.4 | 1031 | 1.0% |
| 16.1 | 1031 | 1.0% |
| 17.4 | 1013 | 1.0% |
| 16.8 | 1007 | 0.9% |
| 0 | 971 | 0.9% |
| 17.2 | 957 | 0.9% |
| Other values (638) | 96279 |
| Value | Count | Frequency (%) |
| 0 | 971 | |
| 0.1 | 609 | |
| 0.2 | 243 | 0.2% |
| 0.3 | 86 | 0.1% |
| 0.4 | 79 | 0.1% |
| 0.5 | 84 | 0.1% |
| 0.6 | 68 | 0.1% |
| 0.7 | 80 | 0.1% |
| 0.8 | 83 | 0.1% |
| 0.9 | 72 | 0.1% |
| Value | Count | Frequency (%) |
| 93.1 | 1 | |
| 84.6 | 1 | |
| 82.5 | 1 | |
| 81 | 1 | |
| 79.8 | 1 | |
| 79.7 | 1 | |
| 78.6 | 1 | |
| 78.1 | 1 | |
| 77.8 | 1 | |
| 77.7 | 1 |
wind_from_direction
Real number (ℝ)
| Distinct | 3598 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 188.45567 |
| Minimum | 0 |
|---|---|
| Maximum | 360 |
| Zeros | 519 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 832.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 8.865 |
| Q1 | 162.6 |
| median | 209.3 |
| Q3 | 230.4 |
| 95-th percentile | 349.1 |
| Maximum | 360 |
| Range | 360 |
| Interquartile range (IQR) | 67.8 |
Descriptive statistics
| Standard deviation | 95.029482 |
|---|---|
| Coefficient of variation (CV) | 0.50425377 |
| Kurtosis | -0.30019307 |
| Mean | 188.45567 |
| Median Absolute Deviation (MAD) | 26.8 |
| Skewness | -0.49972187 |
| Sum | 20088244 |
| Variance | 9030.6025 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 519 | 0.5% |
| 211.7 | 175 | 0.2% |
| 209.1 | 171 | 0.2% |
| 214.2 | 171 | 0.2% |
| 210.7 | 170 | 0.2% |
| 210.3 | 169 | 0.2% |
| 209.2 | 168 | 0.2% |
| 209 | 164 | 0.2% |
| 209.5 | 164 | 0.2% |
| 218 | 163 | 0.2% |
| Other values (3588) | 104560 |
| Value | Count | Frequency (%) |
| 0 | 519 | |
| 0.1 | 38 | < 0.1% |
| 0.2 | 53 | < 0.1% |
| 0.3 | 37 | < 0.1% |
| 0.4 | 41 | < 0.1% |
| 0.5 | 62 | 0.1% |
| 0.6 | 52 | < 0.1% |
| 0.7 | 59 | 0.1% |
| 0.8 | 44 | < 0.1% |
| 0.9 | 46 | < 0.1% |
| Value | Count | Frequency (%) |
| 360 | 24 | < 0.1% |
| 359.9 | 69 | |
| 359.8 | 52 | |
| 359.7 | 49 | |
| 359.6 | 64 | |
| 359.5 | 43 | |
| 359.4 | 55 | |
| 359.3 | 53 | |
| 359.2 | 52 | |
| 359.1 | 46 |
barometric_pressure
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 363 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1000.8149 |
| Minimum | 982.5 |
|---|---|
| Maximum | 1019 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 832.9 KiB |
Quantile statistics
| Minimum | 982.5 |
|---|---|
| 5-th percentile | 989.7 |
| Q1 | 994.9 |
| median | 1000.5 |
| Q3 | 1007.2 |
| 95-th percentile | 1011.5 |
| Maximum | 1019 |
| Range | 36.5 |
| Interquartile range (IQR) | 12.3 |
Descriptive statistics
| Standard deviation | 7.1769299 |
|---|---|
| Coefficient of variation (CV) | 0.0071710862 |
| Kurtosis | -1.0711052 |
| Mean | 1000.8149 |
| Median Absolute Deviation (MAD) | 6.1 |
| Skewness | -0.029299672 |
| Sum | 1.0668086 × 108 |
| Variance | 51.508323 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 997.4 | 723 | 0.7% |
| 995.5 | 656 | 0.6% |
| 996.6 | 630 | 0.6% |
| 1007.7 | 618 | 0.6% |
| 996.3 | 617 | 0.6% |
| 1006.4 | 617 | 0.6% |
| 1008.4 | 611 | 0.6% |
| 1009.5 | 601 | 0.6% |
| 1007.2 | 597 | 0.6% |
| 1007.8 | 596 | 0.6% |
| Other values (353) | 100328 |
| Value | Count | Frequency (%) |
| 982.5 | 2 | < 0.1% |
| 982.6 | 5 | |
| 982.7 | 1 | < 0.1% |
| 982.8 | 3 | |
| 982.9 | 3 | |
| 983 | 5 | |
| 983.2 | 4 | |
| 983.4 | 2 | < 0.1% |
| 983.5 | 1 | < 0.1% |
| 983.6 | 3 |
| Value | Count | Frequency (%) |
| 1019 | 5 | |
| 1018.9 | 4 | |
| 1018.8 | 3 | < 0.1% |
| 1018.7 | 1 | < 0.1% |
| 1018.5 | 3 | < 0.1% |
| 1018.4 | 2 | < 0.1% |
| 1018.3 | 6 | |
| 1018.2 | 9 | |
| 1018.1 | 7 | |
| 1018 | 6 |
sensor_cleaning
Categorical
IMBALANCE 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.1 MiB |
| 0.0 | |
|---|---|
| 1.0 | 153 |
| 0.1 | 1 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 319782 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 106440 | |
| 1.0 | 153 | 0.1% |
| 0.1 | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 106440 | |
| 1.0 | 153 | 0.1% |
| 0.1 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 213034 | |
| . | 106594 | |
| 1 | 154 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 213188 | |
| Other Punctuation | 106594 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 213034 | |
| 1 | 154 | 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 106594 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 319782 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 213034 | |
| . | 106594 | |
| 1 | 154 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 319782 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 213034 | |
| . | 106594 | |
| 1 | 154 | < 0.1% |
comments
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 106594 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 832.9 KiB |
| ghi_pyr | ghi_rsi | dni | dhi | air_temperature | relative_humidity | wind_speed | wind_speed_of_gust | wind_from_direction_st_dev | wind_from_direction | barometric_pressure | sensor_cleaning | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ghi_pyr | 1.000 | 0.981 | 0.933 | 0.948 | 0.506 | -0.429 | 0.116 | 0.187 | 0.461 | -0.177 | -0.086 | 0.040 |
| ghi_rsi | 0.981 | 1.000 | 0.917 | 0.967 | 0.478 | -0.440 | 0.091 | 0.161 | 0.450 | -0.189 | -0.058 | 0.041 |
| dni | 0.933 | 0.917 | 1.000 | 0.840 | 0.404 | -0.468 | 0.031 | 0.098 | 0.435 | -0.204 | 0.051 | 0.042 |
| dhi | 0.948 | 0.967 | 0.840 | 1.000 | 0.485 | -0.384 | 0.141 | 0.204 | 0.432 | -0.175 | -0.121 | 0.033 |
| air_temperature | 0.506 | 0.478 | 0.404 | 0.485 | 1.000 | -0.294 | 0.470 | 0.527 | 0.300 | -0.018 | -0.704 | 0.015 |
| relative_humidity | -0.429 | -0.440 | -0.468 | -0.384 | -0.294 | 1.000 | 0.206 | 0.170 | -0.205 | 0.083 | -0.271 | 0.014 |
| wind_speed | 0.116 | 0.091 | 0.031 | 0.141 | 0.470 | 0.206 | 1.000 | 0.982 | 0.230 | 0.147 | -0.627 | 0.000 |
| wind_speed_of_gust | 0.187 | 0.161 | 0.098 | 0.204 | 0.527 | 0.170 | 0.982 | 1.000 | 0.337 | 0.140 | -0.650 | 0.000 |
| wind_from_direction_st_dev | 0.461 | 0.450 | 0.435 | 0.432 | 0.300 | -0.205 | 0.230 | 0.337 | 1.000 | 0.007 | -0.094 | 0.015 |
| wind_from_direction | -0.177 | -0.189 | -0.204 | -0.175 | -0.018 | 0.083 | 0.147 | 0.140 | 0.007 | 1.000 | -0.125 | 0.010 |
| barometric_pressure | -0.086 | -0.058 | 0.051 | -0.121 | -0.704 | -0.271 | -0.627 | -0.650 | -0.094 | -0.125 | 1.000 | 0.005 |
| sensor_cleaning | 0.040 | 0.041 | 0.042 | 0.033 | 0.015 | 0.014 | 0.000 | 0.000 | 0.015 | 0.010 | 0.005 | 1.000 |
| time | ghi_pyr | ghi_rsi | dni | dhi | air_temperature | relative_humidity | wind_speed | wind_speed_of_gust | wind_from_direction_st_dev | wind_from_direction | barometric_pressure | sensor_cleaning | comments | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2015-04-21 18:30 | 72.1 | 43.2 | 15.0 | 41.7 | 38.7 | 8.6 | 10.5 | 13.6 | 10.4 | 248.5 | 998.2 | 0.0 | NaN |
| 1 | 2015-04-21 18:40 | 37.3 | 22.7 | 0.0 | 22.7 | 38.4 | 8.2 | 10.5 | 13.8 | 10.1 | 252.7 | 998.2 | 0.0 | NaN |
| 2 | 2015-04-21 18:50 | 4.0 | 4.3 | 0.0 | 4.3 | 38.0 | 8.3 | 8.9 | 12.2 | 12.4 | 242.8 | 998.5 | 0.0 | NaN |
| 3 | 2015-04-21 19:00 | 0.0 | 1.2 | 0.0 | 1.2 | 37.7 | 8.8 | 8.8 | 12.7 | 12.6 | 245.7 | 998.6 | 1.0 | NaN |
| 4 | 2015-04-21 19:10 | 0.0 | 0.0 | 0.0 | 0.0 | 37.4 | 9.3 | 8.4 | 11.4 | 12.8 | 244.1 | 998.6 | 1.0 | NaN |
| 5 | 2015-04-21 19:20 | 0.0 | 0.0 | 0.0 | 0.0 | 37.1 | 9.9 | 7.5 | 11.2 | 14.3 | 239.8 | 998.7 | 0.0 | NaN |
| 6 | 2015-04-21 19:30 | 0.0 | 0.0 | 0.0 | 0.0 | 36.7 | 11.1 | 7.6 | 11.4 | 15.4 | 234.9 | 998.9 | 0.0 | NaN |
| 7 | 2015-04-21 19:40 | 0.0 | 0.0 | 0.0 | 0.0 | 36.1 | 13.3 | 8.1 | 12.2 | 16.7 | 230.8 | 998.9 | 0.0 | NaN |
| 8 | 2015-04-21 19:50 | 0.0 | 0.0 | 0.0 | 0.0 | 35.8 | 13.0 | 8.1 | 11.9 | 16.2 | 231.6 | 999.1 | 0.0 | NaN |
| 9 | 2015-04-21 20:00 | 0.0 | 0.0 | 0.0 | 0.0 | 35.5 | 12.6 | 7.6 | 10.9 | 15.9 | 233.7 | 999.2 | 0.0 | NaN |
| time | ghi_pyr | ghi_rsi | dni | dhi | air_temperature | relative_humidity | wind_speed | wind_speed_of_gust | wind_from_direction_st_dev | wind_from_direction | barometric_pressure | sensor_cleaning | comments | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 106584 | 2017-04-30 22:30 | 0.0 | 0.0 | 0.0 | 0.0 | 30.2 | 50.6 | 3.6 | 4.9 | 9.3 | 209.3 | 999.8 | 0.0 | NaN |
| 106585 | 2017-04-30 22:40 | 0.0 | 0.0 | 0.0 | 0.0 | 29.9 | 51.1 | 3.5 | 4.9 | 9.0 | 211.0 | 999.9 | 0.0 | NaN |
| 106586 | 2017-04-30 22:50 | 0.0 | 0.0 | 0.0 | 0.0 | 29.9 | 51.2 | 4.2 | 5.7 | 11.3 | 208.6 | 999.9 | 0.0 | NaN |
| 106587 | 2017-04-30 23:00 | 0.0 | 0.0 | 0.0 | 0.0 | 29.6 | 51.4 | 4.3 | 5.4 | 9.4 | 211.8 | 999.9 | 0.0 | NaN |
| 106588 | 2017-04-30 23:10 | 0.0 | 0.0 | 0.0 | 0.0 | 29.4 | 51.5 | 4.2 | 5.7 | 10.9 | 210.7 | 999.9 | 0.0 | NaN |
| 106589 | 2017-04-30 23:20 | 0.0 | 0.0 | 0.0 | 0.0 | 29.2 | 51.9 | 3.7 | 5.4 | 12.1 | 215.7 | 999.9 | 0.0 | NaN |
| 106590 | 2017-04-30 23:30 | 0.0 | 0.0 | 0.0 | 0.0 | 29.1 | 51.6 | 4.3 | 7.2 | 16.6 | 222.9 | 999.9 | 0.0 | NaN |
| 106591 | 2017-04-30 23:40 | 0.0 | 0.0 | 0.0 | 0.0 | 29.2 | 48.8 | 4.0 | 6.7 | 16.8 | 228.7 | 999.9 | 0.0 | NaN |
| 106592 | 2017-04-30 23:50 | 0.0 | 0.0 | 0.0 | 0.0 | 29.4 | 45.8 | 3.9 | 6.2 | 15.7 | 238.7 | 999.8 | 0.0 | NaN |
| 106593 | 2017-05-01 00:00 | 0.0 | 0.0 | 0.0 | 0.0 | 29.4 | 43.2 | 4.2 | 5.9 | 11.3 | 248.5 | 999.8 | 0.0 | NaN |